﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace WMSABL.Warehouse
{
    public class PD_StockBLL
    {
        DataSet ds = new DataSet();
        PublicDataSet bll = new PublicDataSet();
        private string sql = "SELECT NID,WarehouseNO,PositionNO,ProductNo,Quantity,Unit FROM PD_Stock ";
        /// <summary>
        /// 仓位是否还有库存
        /// </summary>
        public bool PostionQuantity(string Position_Code)
        {
            ds = bll.GetDataSet(" SELECT TOP 1 Quantity FROM PD_Stock  WHERE PositionNO='" + Position_Code + "'");
            if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows[0]["Quantity"].ToString() != "0")
            {
                return true;
            }
            return false;
        }
    }
}
